﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DSCustomer" targetNamespace="http://tempuri.org/DSCustomer.xsd" xmlns:mstns="http://tempuri.org/DSCustomer.xsd" xmlns="http://tempuri.org/DSCustomer.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Karbel4ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Karbel4ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.TX.Properties.Settings.GlobalReference.Default.Karbel4ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerTableAdapter" GeneratorDataComponentClassName="CustomerTableAdapter" Name="Customer" UserDataComponentName="CustomerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.Customer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Customer] WHERE (([CustomerId] = @Original_CustomerId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Customer] ([AccountNumber], [Name], [Demographics], [CountryCode], [PreferredShipMethod], [PreferredPaymentTerm], [VergiDairesi], [VergiNo], [ModifiedDate], [ModifiedBy]) VALUES (@AccountNumber, @Name, @Demographics, @CountryCode, @PreferredShipMethod, @PreferredPaymentTerm, @VergiDairesi, @VergiNo, @ModifiedDate, @ModifiedBy);
SELECT CustomerId, AccountNumber, Name, Demographics, CountryCode, PreferredShipMethod, PreferredPaymentTerm, VergiDairesi, VergiNo, ModifiedDate, ModifiedBy, TS FROM Customer WHERE (CustomerId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AccountNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Xml" Direction="Input" ParameterName="@Demographics" Precision="0" ProviderType="Xml" Scale="0" Size="0" SourceColumn="Demographics" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PreferredShipMethod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PreferredShipMethod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VergiDairesi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VergiDairesi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VergiNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VergiNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CustomerId, AccountNumber, Name, Demographics, CountryCode, PreferredShipMethod, PreferredPaymentTerm, VergiDairesi, VergiNo, ModifiedDate, ModifiedBy, TS FROM dbo.Customer</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Customer] SET [AccountNumber] = @AccountNumber, [Name] = @Name, [Demographics] = @Demographics, [CountryCode] = @CountryCode, [PreferredShipMethod] = @PreferredShipMethod, [PreferredPaymentTerm] = @PreferredPaymentTerm, [VergiDairesi] = @VergiDairesi, [VergiNo] = @VergiNo, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([CustomerId] = @Original_CustomerId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT CustomerId, AccountNumber, Name, Demographics, CountryCode, PreferredShipMethod, PreferredPaymentTerm, VergiDairesi, VergiNo, ModifiedDate, ModifiedBy, TS FROM Customer WHERE (CustomerId = @CustomerId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AccountNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Xml" Direction="Input" ParameterName="@Demographics" Precision="0" ProviderType="Xml" Scale="0" Size="0" SourceColumn="Demographics" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PreferredShipMethod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PreferredShipMethod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VergiDairesi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VergiDairesi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VergiNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VergiNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CustomerId" ColumnName="CustomerId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CustomerId" DataSetColumn="CustomerId" />
              <Mapping SourceColumn="AccountNumber" DataSetColumn="AccountNumber" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Demographics" DataSetColumn="Demographics" />
              <Mapping SourceColumn="CountryCode" DataSetColumn="CountryCode" />
              <Mapping SourceColumn="PreferredShipMethod" DataSetColumn="PreferredShipMethod" />
              <Mapping SourceColumn="PreferredPaymentTerm" DataSetColumn="PreferredPaymentTerm" />
              <Mapping SourceColumn="VergiDairesi" DataSetColumn="VergiDairesi" />
              <Mapping SourceColumn="VergiNo" DataSetColumn="VergiNo" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerAddressTableAdapter" GeneratorDataComponentClassName="CustomerAddressTableAdapter" Name="CustomerAddress" UserDataComponentName="CustomerAddressTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.CustomerAddress" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CustomerAddress] WHERE (([CustomerId] = @Original_CustomerId) AND ([AddressId] = @Original_AddressId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CustomerAddress] ([CustomerId], [AddressId], [AddressTypeId], [ModifiedDate], [ModifiedBy]) VALUES (@CustomerId, @AddressId, @AddressTypeId, @ModifiedDate, @ModifiedBy);
SELECT CustomerId, AddressId, AddressTypeId, ModifiedDate, ModifiedBy, TS FROM CustomerAddress WHERE (AddressId = @AddressId) AND (CustomerId = @CustomerId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AddressTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CustomerId, AddressId, AddressTypeId, ModifiedDate, ModifiedBy, TS FROM dbo.CustomerAddress</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CustomerAddress] SET [CustomerId] = @CustomerId, [AddressId] = @AddressId, [AddressTypeId] = @AddressTypeId, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([CustomerId] = @Original_CustomerId) AND ([AddressId] = @Original_AddressId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT CustomerId, AddressId, AddressTypeId, ModifiedDate, ModifiedBy, TS FROM CustomerAddress WHERE (AddressId = @AddressId) AND (CustomerId = @CustomerId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AddressTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CustomerId" DataSetColumn="CustomerId" />
              <Mapping SourceColumn="AddressId" DataSetColumn="AddressId" />
              <Mapping SourceColumn="AddressTypeId" DataSetColumn="AddressTypeId" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.CustomerAddress" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCustomerId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCustomerId" GeneratorSourceName="FillByCustomerId" GetMethodModifier="Public" GetMethodName="GetDataByCustomerId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCustomerId" UserSourceName="FillByCustomerId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CustomerId, AddressId, AddressTypeId, ModifiedDate, ModifiedBy, TS FROM dbo.CustomerAddress
where CustomerId=@CustomerId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CustomerId" ColumnName="CustomerId" DataSourceName="Karbel4.dbo.CustomerAddress" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AddressTableAdapter" GeneratorDataComponentClassName="AddressTableAdapter" Name="Address" UserDataComponentName="AddressTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.Address" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Address] WHERE (([AddressId] = @Original_AddressId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Address] ([AddressLine1], [AddressLine2], [City], [State], [CountryCode], [PostalCode], [UseCount], [ModifiedDate], [ModifiedBy]) VALUES (@AddressLine1, @AddressLine2, @City, @State, @CountryCode, @PostalCode, @UseCount, @ModifiedDate, @ModifiedBy);
SELECT AddressId, AddressLine1, AddressLine2, City, State, CountryCode, PostalCode, UseCount, ModifiedDate, ModifiedBy, TS FROM Address WHERE (AddressId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AddressLine1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AddressLine2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AddressLine2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PostalCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UseCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UseCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT AddressId, AddressLine1, AddressLine2, City, State, CountryCode, PostalCode, UseCount, ModifiedDate, ModifiedBy, TS FROM dbo.Address</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Address] SET [AddressLine1] = @AddressLine1, [AddressLine2] = @AddressLine2, [City] = @City, [State] = @State, [CountryCode] = @CountryCode, [PostalCode] = @PostalCode, [UseCount] = @UseCount, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([AddressId] = @Original_AddressId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT AddressId, AddressLine1, AddressLine2, City, State, CountryCode, PostalCode, UseCount, ModifiedDate, ModifiedBy, TS FROM Address WHERE (AddressId = @AddressId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AddressLine1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AddressLine2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AddressLine2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PostalCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UseCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UseCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="AddressId" ColumnName="AddressId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AddressId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AddressId" DataSetColumn="AddressId" />
              <Mapping SourceColumn="AddressLine1" DataSetColumn="AddressLine1" />
              <Mapping SourceColumn="AddressLine2" DataSetColumn="AddressLine2" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="CountryCode" DataSetColumn="CountryCode" />
              <Mapping SourceColumn="PostalCode" DataSetColumn="PostalCode" />
              <Mapping SourceColumn="UseCount" DataSetColumn="UseCount" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.Address" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCustomerId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCustomerId" GeneratorSourceName="FillByCustomerId" GetMethodModifier="Public" GetMethodName="GetDataByCustomerId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCustomerId" UserSourceName="FillByCustomerId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AddressId, AddressLine1, AddressLine2, City, State, CountryCode, PostalCode, UseCount, ModifiedDate, ModifiedBy, TS FROM dbo.Address
where AddressId in (select AddressId from CustomerAddress where CustomerId=@CustomerId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CustomerId" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" Scale="0" Size="4" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SalesAgentCustomerTableAdapter" GeneratorDataComponentClassName="SalesAgentCustomerTableAdapter" Name="SalesAgentCustomer" UserDataComponentName="SalesAgentCustomerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.SalesAgentCustomer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SalesAgentCustomer] WHERE (([SalesAgentId] = @Original_SalesAgentId) AND ([CustomerId] = @Original_CustomerId) AND ((@IsNull_CommissionPct = 1 AND [CommissionPct] IS NULL) OR ([CommissionPct] = @Original_CommissionPct)) AND ((@IsNull_PreferredPaymentTerm = 1 AND [PreferredPaymentTerm] IS NULL) OR ([PreferredPaymentTerm] = @Original_PreferredPaymentTerm)) AND ([StartDate] = @Original_StartDate) AND ((@IsNull_EndDate = 1 AND [EndDate] IS NULL) OR ([EndDate] = @Original_EndDate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CommissionPct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_CommissionPct" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PreferredPaymentTerm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SalesAgentCustomer] ([SalesAgentId], [CustomerId], [CommissionPct], [PreferredPaymentTerm], [StartDate], [EndDate]) VALUES (@SalesAgentId, @CustomerId, @CommissionPct, @PreferredPaymentTerm, @StartDate, @EndDate);
SELECT SalesAgentId, CustomerId, CommissionPct, PreferredPaymentTerm, StartDate, EndDate FROM SalesAgentCustomer WHERE (CustomerId = @CustomerId) AND (SalesAgentId = @SalesAgentId) AND (StartDate = @StartDate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CommissionPct" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SalesAgentId, CustomerId, CommissionPct, PreferredPaymentTerm, StartDate, EndDate FROM dbo.SalesAgentCustomer</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SalesAgentCustomer] SET [SalesAgentId] = @SalesAgentId, [CustomerId] = @CustomerId, [CommissionPct] = @CommissionPct, [PreferredPaymentTerm] = @PreferredPaymentTerm, [StartDate] = @StartDate, [EndDate] = @EndDate WHERE (([SalesAgentId] = @Original_SalesAgentId) AND ([CustomerId] = @Original_CustomerId) AND ((@IsNull_CommissionPct = 1 AND [CommissionPct] IS NULL) OR ([CommissionPct] = @Original_CommissionPct)) AND ((@IsNull_PreferredPaymentTerm = 1 AND [PreferredPaymentTerm] IS NULL) OR ([PreferredPaymentTerm] = @Original_PreferredPaymentTerm)) AND ([StartDate] = @Original_StartDate) AND ((@IsNull_EndDate = 1 AND [EndDate] IS NULL) OR ([EndDate] = @Original_EndDate)));
SELECT SalesAgentId, CustomerId, CommissionPct, PreferredPaymentTerm, StartDate, EndDate FROM SalesAgentCustomer WHERE (CustomerId = @CustomerId) AND (SalesAgentId = @SalesAgentId) AND (StartDate = @StartDate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CommissionPct" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CommissionPct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_CommissionPct" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PreferredPaymentTerm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SalesAgentId" DataSetColumn="SalesAgentId" />
              <Mapping SourceColumn="CustomerId" DataSetColumn="CustomerId" />
              <Mapping SourceColumn="CommissionPct" DataSetColumn="CommissionPct" />
              <Mapping SourceColumn="PreferredPaymentTerm" DataSetColumn="PreferredPaymentTerm" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.SalesAgentCustomer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCustomerId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCustomerId" GeneratorSourceName="FillByCustomerId" GetMethodModifier="Public" GetMethodName="GetDataByCustomerId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCustomerId" UserSourceName="FillByCustomerId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT SalesAgentId, CustomerId, CommissionPct, PreferredPaymentTerm, StartDate, EndDate FROM dbo.SalesAgentCustomer
where CustomerId=@CustomerId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CustomerId" ColumnName="CustomerId" DataSourceName="Karbel4.dbo.SalesAgentCustomer" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DSCustomer" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DSCustomer" msprop:Generator_DataSetName="DSCustomer" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Customer" msprop:Generator_UserTableName="Customer" msprop:Generator_RowDeletedName="CustomerRowDeleted" msprop:Generator_RowChangedName="CustomerRowChanged" msprop:Generator_RowClassName="CustomerRow" msprop:Generator_RowChangingName="CustomerRowChanging" msprop:Generator_RowEvArgName="CustomerRowChangeEvent" msprop:Generator_RowEvHandlerName="CustomerRowChangeEventHandler" msprop:Generator_TableClassName="CustomerDataTable" msprop:Generator_TableVarName="tableCustomer" msprop:Generator_RowDeletingName="CustomerRowDeleting" msprop:Generator_TablePropName="Customer">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CustomerId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="CustomerId" msprop:Generator_ColumnVarNameInTable="columnCustomerId" msprop:Generator_ColumnPropNameInRow="CustomerId" msprop:Generator_ColumnPropNameInTable="CustomerIdColumn" type="xs:int" />
              <xs:element name="AccountNumber" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AccountNumber" msprop:Generator_ColumnVarNameInTable="columnAccountNumber" msprop:Generator_ColumnPropNameInRow="AccountNumber" msprop:Generator_ColumnPropNameInTable="AccountNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Demographics" msprop:Generator_UserColumnName="Demographics" msprop:Generator_ColumnVarNameInTable="columnDemographics" msprop:Generator_ColumnPropNameInRow="Demographics" msprop:Generator_ColumnPropNameInTable="DemographicsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PreferredShipMethod" msprop:Generator_UserColumnName="PreferredShipMethod" msprop:Generator_ColumnVarNameInTable="columnPreferredShipMethod" msprop:Generator_ColumnPropNameInRow="PreferredShipMethod" msprop:Generator_ColumnPropNameInTable="PreferredShipMethodColumn" type="xs:int" minOccurs="0" />
              <xs:element name="PreferredPaymentTerm" msprop:Generator_UserColumnName="PreferredPaymentTerm" msprop:Generator_ColumnVarNameInTable="columnPreferredPaymentTerm" msprop:Generator_ColumnPropNameInRow="PreferredPaymentTerm" msprop:Generator_ColumnPropNameInTable="PreferredPaymentTermColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="VergiDairesi" msprop:Generator_UserColumnName="VergiDairesi" msprop:Generator_ColumnVarNameInTable="columnVergiDairesi" msprop:Generator_ColumnPropNameInRow="VergiDairesi" msprop:Generator_ColumnPropNameInTable="VergiDairesiColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VergiNo" msprop:Generator_UserColumnName="VergiNo" msprop:Generator_ColumnVarNameInTable="columnVergiNo" msprop:Generator_ColumnPropNameInRow="VergiNo" msprop:Generator_ColumnPropNameInTable="VergiNoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" />
              <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="SalesAgentCustomer" msprop:Generator_UserTableName="SalesAgentCustomer" msprop:Generator_RowDeletedName="SalesAgentCustomerRowDeleted" msprop:Generator_RowChangedName="SalesAgentCustomerRowChanged" msprop:Generator_RowClassName="SalesAgentCustomerRow" msprop:Generator_RowChangingName="SalesAgentCustomerRowChanging" msprop:Generator_RowEvArgName="SalesAgentCustomerRowChangeEvent" msprop:Generator_RowEvHandlerName="SalesAgentCustomerRowChangeEventHandler" msprop:Generator_TableClassName="SalesAgentCustomerDataTable" msprop:Generator_TableVarName="tableSalesAgentCustomer" msprop:Generator_RowDeletingName="SalesAgentCustomerRowDeleting" msprop:Generator_TablePropName="SalesAgentCustomer" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="SalesAgentId" msprop:Generator_UserColumnName="SalesAgentId" msprop:Generator_ColumnVarNameInTable="columnSalesAgentId" msprop:Generator_ColumnPropNameInRow="SalesAgentId" msprop:Generator_ColumnPropNameInTable="SalesAgentIdColumn" type="xs:int" />
                    <xs:element name="CustomerId" msprop:Generator_UserColumnName="CustomerId" msprop:Generator_ColumnVarNameInTable="columnCustomerId" msprop:Generator_ColumnPropNameInRow="CustomerId" msprop:Generator_ColumnPropNameInTable="CustomerIdColumn" type="xs:int" />
                    <xs:element name="CommissionPct" msprop:Generator_UserColumnName="CommissionPct" msprop:Generator_ColumnVarNameInTable="columnCommissionPct" msprop:Generator_ColumnPropNameInRow="CommissionPct" msprop:Generator_ColumnPropNameInTable="CommissionPctColumn" type="xs:decimal" minOccurs="0" />
                    <xs:element name="PreferredPaymentTerm" msprop:Generator_UserColumnName="PreferredPaymentTerm" msprop:Generator_ColumnVarNameInTable="columnPreferredPaymentTerm" msprop:Generator_ColumnPropNameInRow="PreferredPaymentTerm" msprop:Generator_ColumnPropNameInTable="PreferredPaymentTermColumn" type="xs:unsignedByte" minOccurs="0" />
                    <xs:element name="StartDate" msprop:Generator_UserColumnName="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" type="xs:dateTime" />
                    <xs:element name="EndDate" msprop:Generator_UserColumnName="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" type="xs:dateTime" minOccurs="0" />
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Address" msprop:Generator_UserTableName="Address" msprop:Generator_RowDeletedName="AddressRowDeleted" msprop:Generator_RowChangedName="AddressRowChanged" msprop:Generator_RowClassName="AddressRow" msprop:Generator_RowChangingName="AddressRowChanging" msprop:Generator_RowEvArgName="AddressRowChangeEvent" msprop:Generator_RowEvHandlerName="AddressRowChangeEventHandler" msprop:Generator_TableClassName="AddressDataTable" msprop:Generator_TableVarName="tableAddress" msprop:Generator_RowDeletingName="AddressRowDeleting" msprop:Generator_TablePropName="Address">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AddressId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="AddressId" msprop:Generator_ColumnVarNameInTable="columnAddressId" msprop:Generator_ColumnPropNameInRow="AddressId" msprop:Generator_ColumnPropNameInTable="AddressIdColumn" type="xs:int" />
              <xs:element name="AddressLine1" msprop:Generator_UserColumnName="AddressLine1" msprop:Generator_ColumnVarNameInTable="columnAddressLine1" msprop:Generator_ColumnPropNameInRow="AddressLine1" msprop:Generator_ColumnPropNameInTable="AddressLine1Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddressLine2" msprop:Generator_UserColumnName="AddressLine2" msprop:Generator_ColumnVarNameInTable="columnAddressLine2" msprop:Generator_ColumnPropNameInRow="AddressLine2" msprop:Generator_ColumnPropNameInTable="AddressLine2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_UserColumnName="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_UserColumnName="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PostalCode" msprop:Generator_UserColumnName="PostalCode" msprop:Generator_ColumnVarNameInTable="columnPostalCode" msprop:Generator_ColumnPropNameInRow="PostalCode" msprop:Generator_ColumnPropNameInTable="PostalCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UseCount" msprop:Generator_UserColumnName="UseCount" msprop:Generator_ColumnVarNameInTable="columnUseCount" msprop:Generator_ColumnPropNameInRow="UseCount" msprop:Generator_ColumnPropNameInTable="UseCountColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" />
              <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="CustomerAddress" msprop:Generator_UserTableName="CustomerAddress" msprop:Generator_RowDeletedName="CustomerAddressRowDeleted" msprop:Generator_RowChangedName="CustomerAddressRowChanged" msprop:Generator_RowClassName="CustomerAddressRow" msprop:Generator_RowChangingName="CustomerAddressRowChanging" msprop:Generator_RowEvArgName="CustomerAddressRowChangeEvent" msprop:Generator_RowEvHandlerName="CustomerAddressRowChangeEventHandler" msprop:Generator_TableClassName="CustomerAddressDataTable" msprop:Generator_TableVarName="tableCustomerAddress" msprop:Generator_RowDeletingName="CustomerAddressRowDeleting" msprop:Generator_TablePropName="CustomerAddress" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="CustomerId" msprop:Generator_UserColumnName="CustomerId" msprop:Generator_ColumnVarNameInTable="columnCustomerId" msprop:Generator_ColumnPropNameInRow="CustomerId" msprop:Generator_ColumnPropNameInTable="CustomerIdColumn" type="xs:int" />
                    <xs:element name="AddressId" msprop:Generator_UserColumnName="AddressId" msprop:Generator_ColumnVarNameInTable="columnAddressId" msprop:Generator_ColumnPropNameInRow="AddressId" msprop:Generator_ColumnPropNameInTable="AddressIdColumn" type="xs:int" />
                    <xs:element name="AddressTypeId" msprop:Generator_UserColumnName="AddressTypeId" msprop:Generator_ColumnVarNameInTable="columnAddressTypeId" msprop:Generator_ColumnPropNameInRow="AddressTypeId" msprop:Generator_ColumnPropNameInTable="AddressTypeIdColumn" type="xs:int" />
                    <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" />
                    <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
                    <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="SalesAgentCustomer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SalesAgentCustomer" />
      <xs:field xpath="mstns:SalesAgentId" />
      <xs:field xpath="mstns:CustomerId" />
      <xs:field xpath="mstns:StartDate" />
    </xs:unique>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customer" />
      <xs:field xpath="mstns:CustomerId" />
    </xs:unique>
    <xs:unique name="CustomerAddress_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CustomerAddress" />
      <xs:field xpath="mstns:CustomerId" />
      <xs:field xpath="mstns:AddressId" />
    </xs:unique>
    <xs:unique name="Address_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Address" />
      <xs:field xpath="mstns:AddressId" />
    </xs:unique>
    <xs:keyref name="FK_CustomerAddress_Customer_CustomerId" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_CustomerAddress_Customer_CustomerId" msprop:rel_Generator_RelationVarName="relationFK_CustomerAddress_Customer_CustomerId" msprop:rel_Generator_UserChildTable="CustomerAddress" msprop:rel_Generator_UserParentTable="Customer" msprop:rel_Generator_ParentPropName="CustomerRow" msprop:rel_Generator_ChildPropName="GetCustomerAddressRows">
      <xs:selector xpath=".//mstns:CustomerAddress" />
      <xs:field xpath="mstns:CustomerId" />
    </xs:keyref>
    <xs:keyref name="FK_CustomerAddress_Address_AddressId" refer="Address_Constraint1" msdata:IsNested="true" msprop:rel_Generator_UserRelationName="FK_CustomerAddress_Address_AddressId" msprop:rel_Generator_RelationVarName="relationFK_CustomerAddress_Address_AddressId" msprop:rel_Generator_UserChildTable="CustomerAddress" msprop:rel_Generator_UserParentTable="Address" msprop:rel_Generator_ParentPropName="AddressRow" msprop:rel_Generator_ChildPropName="GetCustomerAddressRows">
      <xs:selector xpath=".//mstns:CustomerAddress" />
      <xs:field xpath="mstns:AddressId" />
    </xs:keyref>
    <xs:keyref name="FK_SalesAgentCustomer_Customer" refer="Constraint1" msdata:IsNested="true" msprop:rel_Generator_UserRelationName="FK_SalesAgentCustomer_Customer" msprop:rel_Generator_RelationVarName="relationFK_SalesAgentCustomer_Customer" msprop:rel_Generator_UserChildTable="SalesAgentCustomer" msprop:rel_Generator_UserParentTable="Customer" msprop:rel_Generator_ParentPropName="CustomerRow" msprop:rel_Generator_ChildPropName="GetSalesAgentCustomerRows">
      <xs:selector xpath=".//mstns:SalesAgentCustomer" />
      <xs:field xpath="mstns:CustomerId" />
    </xs:keyref>
  </xs:element>
</xs:schema>